TRIM () only removes leading and trailing spaces, so 01772 708200 will still remain the same. You would need to use REPLACE() . ... <看更多>

... for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - sql-docs/trim-transact-sql.md at live ... ... <看更多>

... <看更多>

For anyone using SQL Server 2017 or newer. you can use the TRIM built-in function. For example: DECLARE @Test NVARCHAR(4000); SET @Test = N' ' + NCHAR(0x09) ... ... <看更多>